PDA

View Full Version : Excel Help



Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 [93] 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173

  1. sheet protection options
  2. Check if a shape is selected
  3. Editing in Word and saving in Notepad while controlling everything in Excel
  4. Unstable event code
  5. Convert workbook code to worksheet code
  6. Auto print last filled page
  7. Sum of column
  8. Effectively using Classes and Property Let/Get; referring to parent or sub class...
  9. Displaying missing values from 2 worksheets in another separate worksheet
  10. Solved: Deleting part of a merged cell
  11. Solved: Calculate Time Left
  12. Solved: Delete all info other than name on left side of cell.
  13. Login to yahoo mail.
  14. Solved: VBA code for checking possible combinations of 4 numeric digits
  15. copy folder WB to a one workbook
  16. Macro to drill into pivot table
  17. Automation error (Error 440)
  18. Solved: Pivot Table
  19. Dynamic Looping Help
  20. Help to disable popup calendar
  21. Filter Problems
  22. Solved: Enabled Button
  23. Excel VBA Coding for xls transformation
  24. Solved: DoubleClick event in a textbox
  25. copying a range from multiple csv files
  26. Solved: how fix it - vlookup in visible range (not invisible)
  27. Share workbook with digital signature
  28. Solved: Checklist compare
  29. Solved: Zero the negatives
  30. Effect of AND and OR operators on Type Long
  31. Append excel table into Access table on weekly or monthly basis
  32. Solved: To reflect latest data updated in a row range
  33. How to generate weekly/monthly reports from daily report using macros
  34. Changing Chart Titles
  35. Deleting empty worksheets in a workbook
  36. Copying a picture from a web page and pasting into Excel
  37. Solved: goal seek w/ value from another workbook
  38. interact with web page
  39. Compare 4 columns & find dissimilar
  40. Search Function Problem
  41. Round off Issues and more...
  42. Search data within the spreadsheet to log
  43. How to create the menu w/o the code as the attached file
  44. Function Help
  45. Solved: Data Validation: Combine Two Cells In Drop Down Only
  46. find with xlprevious not working
  47. Solved: Dissect result
  48. Search Date in Worksheet and Set Format
  49. Solved: 2003 Multibox Color fix
  50. help with vba code please
  51. Help with code
  52. Solved: Help Date's
  53. Solved: Red Font
  54. Copy data
  55. Problem with If...Then...ElseIf Loop
  56. custom format
  57. Solved: Import Web Data with HTML format
  58. timekeeping template
  59. Problem showing images in locked sheet
  60. Count non empty cells
  61. Getting Error when No visible Cells found. What to do?
  62. Macro to look at list in sheet1, if not in sheet2, pull in
  63. How to re-arrange the listcolumns?
  64. Reading Data and creating a table from it
  65. Textbox Userform: Autopopulate textbox from another textbox
  66. Solved: Lookup County
  67. Updating sheet automatically periodically
  68. Copying a range from a different workbook
  69. Height of Prina Area
  70. Drill into a Pivot Table using a Macro
  71. Data Validation code error
  72. How to destroy (de-filter) individual advanced filters in a worksheet?
  73. Macro vlookup with fill down
  74. Linking dynamically allocated row offset to stacked column chart data range variable.
  75. Solved: loop Error
  76. Solved:Looping a section of code
  77. Solved: Basic VBA problem with Format
  78. Solved: VBA to Excel Add-in
  79. Data Validation based on 2criteria
  80. Solved: Look excel range?
  81. Make a report with data taken from cells
  82. Solved: Delete Empty Cells
  83. Solved: Entering Value in Combobox with Dynamic Range
  84. cannot get rid of error message
  85. Why doesn't the xlcelltypelastcell not giving the last cell inside a list?
  86. Move files and ignore file extension?
  87. vlookup with input box to select a new month when run
  88. Set the values for .TextFileFixedColumnWidths in code
  89. Solved: concatenate cells in IF statements
  90. List Ranges with Missing Data in Column
  91. HTML table code
  92. Solved: Range Selection error
  93. Moving to Excel 2010 - worksheets.move compatibility
  94. Macro: Highlight Cell in Col B that DOES NOT exist in Col A
  95. Help Exiting Loop
  96. Combo box in Excel to query MySQL
  97. Unlock Blank Cells in Column G
  98. Advanced Filter Command Buttons
  99. Copying Characters to the Right of a Selected String in a .txt file
  100. Drop Down Validation Double Dependency
  101. How to password protect grouping?
  102. Solved: SUM Formula
  103. Cells that update automatically
  104. VBA Data Analysis Loop Problem
  105. Creating a list of variables
  106. Unhide bug
  107. Solved: Range matrix
  108. Solved: multiple interior.colorindex
  109. Solved: error handling failed
  110. [SOLVED] Conditional Formatting Help :-)
  111. Solved: Range selection with array of ranges
  112. Solved: Cannot switch to an active excel workbook from word
  113. Code understanding
  114. Create worksheets from a list
  115. Solved: Find
  116. Tricking Sort Logic
  117. Convert UTC to local time with DST
  118. E-mailer from individual e-mail to 1 e-mail
  119. Solved: Setting wb.Name to string for VLOOKUP formula
  120. Solved: searching a word in lower and uppercase
  121. Replace Chart labels with Textboxs
  122. Question about vba programming
  123. how to search for a string in text file
  124. Solved: Shell and Wait Issue
  125. Solved: Stripping numbers from alphanumeric strings
  126. Solved: Delete Rows
  127. VBA code to hide rows
  128. Solved: Listbox1: Highlight Pre selected Item
  129. Copy Paste File Specified in Cell to Another Folder
  130. Confusing issue with Copying and moving work tabs
  131. Solved: Quick VBA Userform Pivot query
  132. Solved: Copy from one workbook, to another, keeping format.
  133. connetct own help file in excelVBA function addina
  134. Problem with .xlsm file adding code via VBA
  135. Solved: Strange Error in simple VBA macro
  136. userform filtered search
  137. Solved: Sumproduct with HLookup
  138. Solved: Find text in a cell,copy row and paste into new sheet
  139. How To Copy Paste File Named in Cell to Another Folder Named in Cell?
  140. RGB (R, G, B) to hex function
  141. VBA Code Freezing
  142. Need Help - Macro Not Working Properly
  143. Compare two spreadsheets
  144. Solved: VBA for updating every worksheet in workbook.
  145. [SOLVED] Problem with more then one each.. for cicle
  146. Solved: Display the first word separated by comma in textbox
  147. Filling in IE form with values from Excel
  148. Solved: Strange problem when protecting/unprotecting sheets
  149. Solved: copy cells to column without blanks
  150. saving spreadheet to network drive
  151. Converting Matlab Code to Vba
  152. Why the Set temp(0) = Activesheet.Columns(3).insert is not working?
  153. VBA Help
  154. Solved: Workbooks.Open issue in Excel 2010 (Network Drive)
  155. VBA Excel Transpose all files in a folder
  156. Solved: Conditional Format 2 arguments; one of them is only a part of a cell contents
  157. Comparing string differences between two separate column of sheets???
  158. Merge first sheet of multiple excel file
  159. Solved: Userform Option Button Issues
  160. replacing characters in a column which occu at random positions
  161. Publishing Defined Names to single Htm page
  162. Expressing a " in an excel Formula as VBA code
  163. Solved: Filter and VBA
  164. Solved: VLOOKUP Code
  165. Solved: Allow Authorisation On 2 Computers
  166. Solved: Application.Countif - separate workbook
  167. Solved: VBA Copy
  168. save as with auto name
  169. Solved: Speed up an Array Formula in VBA
  170. Solved: UserForms: Passing inputs from one to another
  171. Reading values from a closed excel sheet
  172. Solved: making a list of the datasheet
  173. Sorting Options for Several Data
  174. Compare two spreadsheets-Macro
  175. Debugging Runtime Error '13' Type Mismatch
  176. Solved: MsgBox to list missing .references
  177. on each day, at 6am, the excel file will be opened by itself
  178. Macro Help: Replacement for cut and delete Speed wise
  179. Sorting sheets within a workbook
  180. Solved: rd_filename = Active.Workbook.Name
  181. Find cells within range equal to 70% of sum of total range
  182. Solved: select worksheet and display selected sheet in workbook
  183. Master Filter for Pivot Tables
  184. Solved: make VBA code shorter
  185. Problem with VBA script reading from MySql database
  186. Solved: Working on a not visible Worksheet
  187. String and Combox Question
  188. Solved: Not understanding Custom Icon Macro
  189. Return Types in Excel VBA
  190. Solved: Insert Row after Specific Text
  191. Solved: Runing a macro by clicking on a sheet
  192. Delete and Move a row in excel
  193. Automate Click, Save Close
  194. Make a simple report with VBA
  195. Solved: userform multiselect listbox - select item
  196. mutliselect listbox via looping a range
  197. Extract email out of changing string count
  198. controlling cell entries
  199. Solved: Re-calculating cells with unrecognized functions
  200. Copy text from Word and paste into Excel VBA
  201. Solved: Msgbox interrupts drawing on worksheet
  202. Solved: Separate generated password with dashes
  203. Cannot Insert Column
  204. VBA web queries - error 1004 "The site reports that the address is not valid"
  205. Solved: variable formular depending on number of work sheets
  206. SendKeyys command turns off Numlock
  207. Two Columns (Search and Copy)
  208. Comboboxes filling with for loop
  209. Declaring global Boolean variable?
  210. read/write to textfile
  211. Loop through all visible worksheets in excel
  212. On error resume next
  213. Is it possible to automate results from an access query into Excel?
  214. Using data collected in a module/ macro
  215. Solved: Variable dimension of a matrix
  216. Solved: Copy deleted info
  217. FileDateTime(pathname)
  218. find info in cells,delete cells with no info and paste to printsheet. then repeat
  219. Is it possible to do automation to control another application through vba code?
  220. [SOLVED] Need help in event
  221. VBA code to import pdf as txt to Excel
  222. Solved: .Find not working between Workbooks
  223. Solved: PRICING GRID
  224. Copy WS to a Named WS values only
  225. Auto open file at fixed length of time
  226. Copying File issue
  227. Solved: Problem with ListBox
  228. Swapping Cells
  229. Solved: Problem with declarations and Str function
  230. Solved: Message Box Reminder
  231. Solved: Problem with cut/paste to last row of sheets
  232. right-click in textbox
  233. Solved: Start Counting when cell changes
  234. How to pick the random numbers from a set of numbers
  235. draw arrows
  236. Solved: Setting filters from a form
  237. Solved: Creation of Folders and Sub-Folder
  238. Insert picture in sheet + send range via email
  239. Solved: VBA to calculate last month
  240. Solved: Page Break
  241. How to Connect to an API
  242. Solved: Returning TextBox data to msgbox or cell
  243. Solved: copy first sheets from all work books in a file into a collective sheet
  244. Get Final URLS?
  245. Solved: Help modifying excel timer
  246. how to create a aktive excel table
  247. getting #N/A as value
  248. oracle connectivity
  249. Solved: Help with Commad bar
  250. Solved: vba to open web page in IE and save it