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 174

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